
-- ----------------------------
-- Table structure for ad
-- ----------------------------
DROP TABLE [dbo].[ad]
GO
CREATE TABLE [dbo].[ad] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(255) NULL ,
[classid] int NULL ,
[src] varchar(255) NULL ,
[url] varchar(255) NULL ,
[ordnum] int NULL ,
[alt] varchar(255) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[ad]', RESEED, 3)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'ad', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'ad'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ad'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'ad'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ad'
GO

-- ----------------------------
-- Records of ad
-- ----------------------------
SET IDENTITY_INSERT [dbo].[ad] ON
GO
INSERT INTO [dbo].[ad] ([ID], [title], [classid], [src], [url], [ordnum], [alt]) VALUES (N'1', N'Logo名称', N'1', N'/skin/images/logo.png', N'http://jian.wlfimms.com', N'99', N'Logo名称描述显示在alt标签和链接上')
GO
GO
INSERT INTO [dbo].[ad] ([ID], [title], [classid], [src], [url], [ordnum], [alt]) VALUES (N'2', N'tel', N'2', N'/skin/images/tel.png', N'/', N'99', N'tel')
GO
GO
INSERT INTO [dbo].[ad] ([ID], [title], [classid], [src], [url], [ordnum], [alt]) VALUES (N'3', N'banner1', N'3', N'/skin/images/banner1.jpg', null, N'99', null)
GO
GO
SET IDENTITY_INSERT [dbo].[ad] OFF
GO

-- ----------------------------
-- Table structure for adclass
-- ----------------------------
DROP TABLE [dbo].[adclass]
GO
CREATE TABLE [dbo].[adclass] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(255) NULL ,
[tag] varchar(255) NULL ,
[endtime] datetime NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[adclass]', RESEED, 3)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'adclass', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'adclass'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'adclass'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'adclass'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'adclass'
GO

-- ----------------------------
-- Records of adclass
-- ----------------------------
SET IDENTITY_INSERT [dbo].[adclass] ON
GO
INSERT INTO [dbo].[adclass] ([ID], [title], [tag], [endtime]) VALUES (N'1', N'logo', N'logo', N'2028-08-16 09:39:21.387')
GO
GO
INSERT INTO [dbo].[adclass] ([ID], [title], [tag], [endtime]) VALUES (N'2', N'tel', N'tel', N'2028-08-16 09:39:27.250')
GO
GO
INSERT INTO [dbo].[adclass] ([ID], [title], [tag], [endtime]) VALUES (N'3', N'banner', N'banner', N'2028-08-16 09:39:32.340')
GO
GO
SET IDENTITY_INSERT [dbo].[adclass] OFF
GO

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE [dbo].[admin]
GO
CREATE TABLE [dbo].[admin] (
[ID] int NOT NULL IDENTITY(1,1) ,
[utype] int NULL ,
[username] varchar(50) NULL ,
[password] varchar(50) NULL ,
[logintime] datetime NULL ,
[hits] int NULL ,
[ip] varchar(20) NULL ,
[penname] varchar(50) NULL ,
[addtime] datetime NULL ,
[endtime] datetime NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'admin', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'admin'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'admin'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'admin'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'admin'
GO

-- ----------------------------
-- Records of admin
-- ----------------------------
SET IDENTITY_INSERT [dbo].[admin] ON
GO
INSERT INTO [dbo].[admin] ([ID], [utype], [username], [password], [logintime], [hits], [ip], [penname], [addtime], [endtime]) VALUES (N'1', N'1', N'admin', N'1F40B82F402EEE06', N'2018-08-21 10:29:11.703', N'215', N'::1', N'超管', N'2018-06-26 10:43:13.000', N'2020-11-01 10:43:16.000')
GO
GO
SET IDENTITY_INSERT [dbo].[admin] OFF
GO

-- ----------------------------
-- Table structure for admintype
-- ----------------------------
DROP TABLE [dbo].[admintype]
GO
CREATE TABLE [dbo].[admintype] (
[ID] int NOT NULL IDENTITY(1,1) ,
[typename] varchar(30) NULL ,
[system] int NULL ,
[purviews] varchar(MAX) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[admintype]', RESEED, 2)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'admintype', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'admintype'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'admintype'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'admintype'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'admintype'
GO

-- ----------------------------
-- Records of admintype
-- ----------------------------
SET IDENTITY_INSERT [dbo].[admintype] ON
GO
INSERT INTO [dbo].[admintype] ([ID], [typename], [system], [purviews]) VALUES (N'1', N'超级管理员', N'1', N'allowall')
GO
GO
INSERT INTO [dbo].[admintype] ([ID], [typename], [system], [purviews]) VALUES (N'2', N'普通管理员', N'0', null)
GO
GO
SET IDENTITY_INSERT [dbo].[admintype] OFF
GO

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE [dbo].[category]
GO
CREATE TABLE [dbo].[category] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(200) NULL ,
[fid] int NULL ,
[pic] varchar(200) NULL ,
[ordnum] int NULL ,
[bannerpic] varchar(200) NULL ,
[skin] varchar(50) NULL ,
[pageskin] varchar(50) NULL ,
[page_title] varchar(300) NULL ,
[mpage_title] varchar(300) NULL ,
[page_key] varchar(300) NULL ,
[mpage_key] varchar(300) NULL ,
[page_desc] varchar(2000) NULL ,
[mpage_desc] varchar(2000) NULL ,
[body] varchar(MAX) NULL ,
[content] varchar(MAX) NULL ,
[mcontent] varchar(MAX) NULL ,
[hits] int NULL ,
[pnum] int NULL DEFAULT ((20)) ,
[mpnum] int NULL DEFAULT ((14)) ,
[addtime] datetime NULL ,
[updatetime] datetime NULL ,
[sid] int NULL ,
[mid] int NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[category]', RESEED, 10)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'category', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'category'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'category'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'category'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'category'
GO

-- ----------------------------
-- Records of category
-- ----------------------------
SET IDENTITY_INSERT [dbo].[category] ON
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'1', N'产品中心', N'0', null, N'99', null, N'plist', N'product', null, null, null, null, null, null, null, null, null, N'61', N'15', N'2', N'2018-08-16 09:54:25.000', N'2018-08-16 09:54:25.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'2', N'新闻中心', N'0', null, N'99', null, N'nlist', N'news', null, null, null, null, null, null, null, null, null, N'15', N'15', N'14', N'2018-08-16 09:55:59.850', N'2018-08-16 09:55:59.850', N'1', N'1')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'3', N'关于我们', N'0', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'8', N'15', N'14', N'2018-08-16 09:56:11.270', N'2018-08-16 09:56:11.270', N'1', N'1')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'4', N'男装', N'1', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'0', N'15', N'14', N'2018-08-16 10:12:35.870', N'2018-08-16 10:12:35.870', N'1', N'1')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'5', N'童装', N'1', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'0', N'15', N'14', N'2018-08-16 10:12:46.893', N'2018-08-16 10:12:46.893', N'1', N'1')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'6', N'鞋子', N'1', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'0', N'15', N'14', N'2018-08-16 10:12:54.000', N'2018-08-16 10:12:54.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'7', N'T恤衫', N'1', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'0', N'15', N'14', N'2018-08-16 10:13:22.307', N'2018-08-16 10:13:22.307', N'1', N'1')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'8', N'公司新闻', N'2', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'0', N'15', N'14', N'2018-08-16 11:37:20.000', N'2018-08-16 11:37:20.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'9', N'行业知识', N'2', null, N'99', null, null, null, null, null, null, null, null, null, null, null, null, N'0', N'15', N'14', N'2018-08-16 11:37:37.793', N'2018-08-16 11:37:37.793', N'1', N'1')
GO
GO
INSERT INTO [dbo].[category] ([ID], [title], [fid], [pic], [ordnum], [bannerpic], [skin], [pageskin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [content], [mcontent], [hits], [pnum], [mpnum], [addtime], [updatetime], [sid], [mid]) VALUES (N'10', N'企业图库', N'0', null, N'99', null, N'piclist', N'pics', null, null, null, null, null, null, null, null, null, N'8', N'15', N'14', N'2018-08-20 17:39:56.187', N'2018-08-20 17:39:56.187', N'1', N'1')
GO
GO
SET IDENTITY_INSERT [dbo].[category] OFF
GO

-- ----------------------------
-- Table structure for info
-- ----------------------------
DROP TABLE [dbo].[info]
GO
CREATE TABLE [dbo].[info] (
[ID] int NOT NULL IDENTITY(1,1) ,
[name] varchar(100) NULL ,
[weburl] varchar(300) NULL ,
[pre_title] varchar(50) NULL ,
[end_title] varchar(50) NULL ,
[page_title] varchar(300) NULL ,
[mpage_title] varchar(300) NULL ,
[page_key] varchar(300) NULL ,
[mpage_key] varchar(300) NULL ,
[page_desc] varchar(2000) NULL ,
[mpage_desc] varchar(2000) NULL ,
[body] varchar(MAX) NULL ,
[mbody] varchar(MAX) NULL ,
[copyright] varchar(MAX) NULL ,
[mcopyright] varchar(MAX) NULL ,
[tel] varchar(20) NULL ,
[mobile] varchar(20) NULL ,
[qq] varchar(20) NULL ,
[email] varchar(100) NULL ,
[skin] varchar(50) NULL ,
[mskin] varchar(50) NULL ,
[hits] int NULL ,
[bannerpic] varchar(200) NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'info', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'info'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'info'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'info'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'info'
GO

-- ----------------------------
-- Records of info
-- ----------------------------
SET IDENTITY_INSERT [dbo].[info] ON
GO
INSERT INTO [dbo].[info] ([ID], [name], [weburl], [pre_title], [end_title], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [body], [mbody], [copyright], [mcopyright], [tel], [mobile], [qq], [email], [skin], [mskin], [hits], [bannerpic]) VALUES (N'1', N'网立方(简)CMS网站管理系统演示Demo', N'http://jian.wlfimms.com', null, null, N'网立方(简)CMS网站管理系统演示Demo', N'手机站首页', N'CMS,建站系统', N'1', N'一套简单好用的.NET建站系统', N'2', null, N'<p>首页内容</p>', N'<p>版权所有：巩义市支点电子商务有限公司</p>', N'<p>版权信息</p>', N'037168676867', null, null, null, null, null, N'135', N'/skin/images/banner1.jpg')
GO
GO
SET IDENTITY_INSERT [dbo].[info] OFF
GO

-- ----------------------------
-- Table structure for jxinxi
-- ----------------------------
DROP TABLE [dbo].[jxinxi]
GO
CREATE TABLE [dbo].[jxinxi] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(200) NULL ,
[etitle] varchar(500) NULL ,
[flag] varchar(50) NULL ,
[content] varchar(MAX) NULL ,
[addtime] datetime NULL ,
[updatetime] datetime NULL ,
[sid] int NULL ,
[mid] int NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[jxinxi]', RESEED, 3)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'jxinxi', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'jxinxi'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'jxinxi'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'jxinxi'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'jxinxi'
GO

-- ----------------------------
-- Records of jxinxi
-- ----------------------------
SET IDENTITY_INSERT [dbo].[jxinxi] ON
GO
INSERT INTO [dbo].[jxinxi] ([ID], [title], [etitle], [flag], [content], [addtime], [updatetime], [sid], [mid]) VALUES (N'1', N'企业文化', null, N'产品下文字1', N'XXXX有限公司成立于20XX年X月，总部位于XX，目前共有XX人，XXXX有限公司成立于20XX年X月......', N'1753-01-01 00:00:00.000', N'1753-01-01 00:00:00.000', N'1', N'1')
GO
GO
INSERT INTO [dbo].[jxinxi] ([ID], [title], [etitle], [flag], [content], [addtime], [updatetime], [sid], [mid]) VALUES (N'2', N'服务承诺', null, N'产品下文字2', N'<p>XXXX有限公司成立于20XX年X月，总部位于XX，目前共有XX人，XXXX有限公司成立于20XX年X月......</p>', N'1753-01-01 00:00:00.000', N'1753-01-01 00:00:00.000', N'1', N'1')
GO
GO
INSERT INTO [dbo].[jxinxi] ([ID], [title], [etitle], [flag], [content], [addtime], [updatetime], [sid], [mid]) VALUES (N'3', N'机构组织', null, N'产品下文字3', N'<p>XXXX有限公司成立于20XX年X月，总部位于XX，目前共有XX人，XXXX有限公司成立于20XX年X月......</p>', N'1753-01-01 00:00:00.000', N'1753-01-01 00:00:00.000', N'1', N'1')
GO
GO
SET IDENTITY_INSERT [dbo].[jxinxi] OFF
GO

-- ----------------------------
-- Table structure for links
-- ----------------------------
DROP TABLE [dbo].[links]
GO
CREATE TABLE [dbo].[links] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(255) NULL ,
[url] varchar(255) NULL ,
[img] varchar(255) NULL ,
[ordnum] int NULL ,
[addtime] datetime NULL ,
[endtime] datetime NULL ,
[ismobile] int NULL ,
[mid] int NULL ,
[sid] int NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'links', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'links'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'links'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'links'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'links'
GO

-- ----------------------------
-- Records of links
-- ----------------------------
SET IDENTITY_INSERT [dbo].[links] ON
GO
INSERT INTO [dbo].[links] ([ID], [title], [url], [img], [ordnum], [addtime], [endtime], [ismobile], [mid], [sid]) VALUES (N'1', N'巩义市支点电子商务有限公司', N'http://www.gyqiye.com', null, N'99', N'2018-08-16 09:58:10.640', N'2019-08-16 09:57:53.333', N'0', N'1', N'1')
GO
GO
SET IDENTITY_INSERT [dbo].[links] OFF
GO

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE [dbo].[log]
GO
CREATE TABLE [dbo].[log] (
[ID] int NOT NULL IDENTITY(1,1) ,
[mid] int NULL ,
[title] varchar(100) NULL ,
[addtime] datetime NULL ,
[ip] varchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[log]', RESEED, 2)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'log', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'log'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'log'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'log'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'log'
GO

-- ----------------------------
-- Records of log
-- ----------------------------
SET IDENTITY_INSERT [dbo].[log] ON
GO
SET IDENTITY_INSERT [dbo].[log] OFF
GO

-- ----------------------------
-- Table structure for nav
-- ----------------------------
DROP TABLE [dbo].[nav]
GO
CREATE TABLE [dbo].[nav] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(50) NULL ,
[etitle] varchar(100) NULL ,
[url] varchar(200) NULL ,
[classid] int NULL ,
[ordnum] int NULL ,
[target] varchar(255) NULL ,
[ismobile] int NULL ,
[sid] int NULL ,
[mid] int NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[nav]', RESEED, 11)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'nav', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'nav'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'nav'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'nav'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'nav'
GO

-- ----------------------------
-- Records of nav
-- ----------------------------
SET IDENTITY_INSERT [dbo].[nav] ON
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'1', N'网站首页', N'HOME', N'/', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'2', N'关于我们', N'About', N'/article/1', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'3', N'产品中心', N'Product', N'/list/1', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'4', N'新闻中心', N'News', N'/list/2', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'5', N'公司图库', N'Pictures', N'/list/10', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'6', N'联系我们', N'Contact', N'/article/2', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'7', N'网站地图', N'Sitemap', N'/sitemap.xml', N'0', N'0', N'_self', N'0', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'8', N'首页', null, N'/', N'0', N'0', N'_self', N'1', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'9', N'简介', null, N'/article/1', N'0', N'0', N'_self', N'1', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'10', N'产品', null, N'/list/1', N'0', N'0', N'_self', N'1', N'1', N'1')
GO
GO
INSERT INTO [dbo].[nav] ([ID], [title], [etitle], [url], [classid], [ordnum], [target], [ismobile], [sid], [mid]) VALUES (N'11', N'新闻', null, N'/list/2', N'0', N'0', N'_self', N'1', N'1', N'1')
GO
GO
SET IDENTITY_INSERT [dbo].[nav] OFF
GO

-- ----------------------------
-- Table structure for sysinfo
-- ----------------------------
DROP TABLE [dbo].[sysinfo]
GO
CREATE TABLE [dbo].[sysinfo] (
[ID] int NOT NULL IDENTITY(1,1) ,
[k] varchar(255) NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'sysinfo', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'sysinfo'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'sysinfo'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'sysinfo'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'sysinfo'
GO

-- ----------------------------
-- Records of sysinfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sysinfo] ON
GO
INSERT INTO [dbo].[sysinfo] ([ID], [k]) VALUES (N'1', N'FC799B195996D398FBE305EEB28D8B2C')
GO
GO
SET IDENTITY_INSERT [dbo].[sysinfo] OFF
GO

-- ----------------------------
-- Table structure for xbody
-- ----------------------------
DROP TABLE [dbo].[xbody]
GO
CREATE TABLE [dbo].[xbody] (
[ID] int NOT NULL IDENTITY(1,1) ,
[xid] int NULL ,
[content] varchar(MAX) NULL ,
[mcontent] varchar(MAX) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[xbody]', RESEED, 15)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'xbody', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'xbody'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'xbody'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'xbody'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'xbody'
GO

-- ----------------------------
-- Records of xbody
-- ----------------------------
SET IDENTITY_INSERT [dbo].[xbody] ON
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'1', N'1', N'<p>公司简介内容</p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'2', N'2', N'<p>联系我们内容</p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'3', N'3', N'<p><img src="/upload/image/demo/t3.jpg" alt="t3.jpg" width="750" height="750" title="t3.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'4', N'4', N'<p><img src="/upload/image/demo/t1.jpg" alt="t1.jpg" width="750" height="750" title="t1.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'5', N'5', N'<p><img src="/upload/image/demo/t2.jpg" alt="t2.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'6', N'6', N'<p><img src="/upload/image/demo/x2.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'7', N'7', N'<p><img src="/upload/image/demo/x1.jpg" alt="x1.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'8', N'8', N'<p><img src="/upload/image/demo/tz2.jpg" alt="tz2.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'9', N'9', N'<p><img src="/upload/image/demo/tz3.jpg" alt="tz3.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'10', N'10', null, null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'11', N'11', N'<p><img src="/upload/image/demo/pd.png" alt="pd.png"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'12', N'12', null, null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'13', N'13', N'<p><img src="/upload/image/demo/xw1.jpg" alt="xw1.jpg"/></p>', null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'14', N'14', null, null)
GO
GO
INSERT INTO [dbo].[xbody] ([ID], [xid], [content], [mcontent]) VALUES (N'15', N'15', N'<p><img src="/upload/image/demo/t1.jpg" alt="t1.jpg"/></p>', null)
GO
GO
SET IDENTITY_INSERT [dbo].[xbody] OFF
GO

-- ----------------------------
-- Table structure for xinxi
-- ----------------------------
DROP TABLE [dbo].[xinxi]
GO
CREATE TABLE [dbo].[xinxi] (
[ID] int NOT NULL IDENTITY(1,1) ,
[title] varchar(255) NULL ,
[classid] int NULL ,
[flag] varchar(200) NULL ,
[pic] varchar(200) NULL ,
[pics] varchar(2000) NULL ,
[ordnum] int NULL ,
[url] varchar(200) NULL ,
[bannerpic] varchar(200) NULL ,
[skin] varchar(50) NULL ,
[page_title] varchar(300) NULL ,
[mpage_title] varchar(300) NULL ,
[page_key] varchar(300) NULL ,
[mpage_key] varchar(300) NULL ,
[page_desc] varchar(2000) NULL ,
[mpage_desc] varchar(2000) NULL ,
[jbody] varchar(MAX) NULL ,
[body] varchar(MAX) NULL ,
[ding] int NULL ,
[cai] int NULL ,
[hits] int NULL ,
[author] varchar(30) NULL ,
[source] varchar(200) NULL ,
[addtime] datetime NULL ,
[updatetime] datetime NULL ,
[sid] int NULL ,
[mid] int NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[xinxi]', RESEED, 15)
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'xinxi', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'xinxi'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'xinxi'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'xinxi'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'xinxi'
GO

-- ----------------------------
-- Records of xinxi
-- ----------------------------
SET IDENTITY_INSERT [dbo].[xinxi] ON
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'1', N'公司简介', N'3', null, null, null, N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'30', null, null, N'2018-08-16 09:56:32.367', N'2018-08-16 09:56:32.367', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'2', N'联系我们', N'3', null, null, null, N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'6', null, null, N'2018-08-16 09:56:44.417', N'2018-08-16 09:56:44.417', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'3', N'体恤背面', N'7', N'n', N'/upload/image/demo/t3.jpg', N'/upload/image/demo/t3.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'2', null, null, N'2018-08-16 10:26:56.000', N'2018-08-16 10:26:56.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'4', N'体恤三色', N'7', N'n', N'/upload/image/demo/t1.jpg', N'/upload/image/demo/t1.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'2', null, null, N'2018-08-16 10:28:02.000', N'2018-08-16 10:28:02.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'5', N'体恤灰', N'7', N'n', N'/upload/image/demo/t2.jpg', N'/upload/image/demo/t2.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'5', null, null, N'2018-08-16 10:28:28.000', N'2018-08-16 10:28:28.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'6', N'女鞋粉色', N'6', null, N'/upload/image/demo/x2.jpg', N'/upload/image/demo/x2.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'1', null, null, N'2018-08-16 11:27:46.647', N'2018-08-16 11:27:46.647', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'7', N'男鞋黑色', N'6', null, N'/upload/image/demo/x1.jpg', N'/upload/image/demo/x1.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'2', null, null, N'2018-08-16 11:29:15.940', N'2018-08-16 11:29:15.940', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'8', N'童装粉色', N'5', N'n', N'/upload/image/demo/tz2.jpg', N'/upload/image/demo/tz2.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'4', null, null, N'2018-08-16 11:29:48.600', N'2018-08-16 11:29:48.600', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'9', N'童装紫色', N'5', null, N'/upload/image/demo/tz3.jpg', N'/upload/image/demo/tz3.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'8', null, null, N'2018-08-16 11:30:18.477', N'2018-08-16 11:30:18.477', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'10', N'服装行业的行业规则你知道哪些', N'9', null, null, null, N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'0', null, null, N'2018-08-16 11:38:04.160', N'2018-08-16 11:38:04.160', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'11', N'为什么我们的帽子销量这么厉害', N'9', null, N'/upload/image/demo/pd.png', N'/upload/image/demo/pd.png', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'0', null, null, N'2018-08-16 11:38:19.000', N'2018-08-16 11:38:19.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'12', N'男款T恤衫爆款销售已经无法控制', N'9', null, null, null, N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'0', null, null, N'2018-08-16 11:38:54.217', N'2018-08-16 11:38:54.217', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'13', N'公司新购进一批漂亮的女款衣服，正在热销中', N'8', null, N'/upload/image/demo/xw1.jpg', N'/upload/image/demo/xw1.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'3', null, null, N'2018-08-16 11:39:17.000', N'2018-08-16 11:39:17.000', N'0', N'0')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'14', N'热烈庆祝公司活动圆满启动，欢迎广大新老用户前来参加', N'8', null, null, null, N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'4', null, null, N'2018-08-16 11:39:51.630', N'2018-08-16 11:39:51.630', N'1', N'1')
GO
GO
INSERT INTO [dbo].[xinxi] ([ID], [title], [classid], [flag], [pic], [pics], [ordnum], [url], [bannerpic], [skin], [page_title], [mpage_title], [page_key], [mpage_key], [page_desc], [mpage_desc], [jbody], [body], [ding], [cai], [hits], [author], [source], [addtime], [updatetime], [sid], [mid]) VALUES (N'15', N'图片1', N'10', N'n', N'/upload/image/demo/t1.jpg', N'/upload/image/demo/t1.jpg', N'0', null, null, null, null, null, null, null, null, null, null, null, N'0', N'0', N'3', null, null, N'2018-08-21 09:13:43.393', N'2018-08-21 09:13:43.393', N'1', N'1')
GO
GO
SET IDENTITY_INSERT [dbo].[xinxi] OFF
GO

-- ----------------------------
-- Indexes structure for table ad
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table ad
-- ----------------------------
ALTER TABLE [dbo].[ad] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table adclass
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table adclass
-- ----------------------------
ALTER TABLE [dbo].[adclass] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table admin
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table admin
-- ----------------------------
ALTER TABLE [dbo].[admin] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table admintype
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table admintype
-- ----------------------------
ALTER TABLE [dbo].[admintype] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table category
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table category
-- ----------------------------
ALTER TABLE [dbo].[category] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table info
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table info
-- ----------------------------
ALTER TABLE [dbo].[info] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table jxinxi
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table jxinxi
-- ----------------------------
ALTER TABLE [dbo].[jxinxi] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table links
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table links
-- ----------------------------
ALTER TABLE [dbo].[links] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table log
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table log
-- ----------------------------
ALTER TABLE [dbo].[log] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table nav
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table nav
-- ----------------------------
ALTER TABLE [dbo].[nav] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table sysinfo
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table sysinfo
-- ----------------------------
ALTER TABLE [dbo].[sysinfo] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table xbody
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table xbody
-- ----------------------------
ALTER TABLE [dbo].[xbody] ADD PRIMARY KEY ([ID])
GO

-- ----------------------------
-- Indexes structure for table xinxi
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table xinxi
-- ----------------------------
ALTER TABLE [dbo].[xinxi] ADD PRIMARY KEY ([ID])
GO
